<?php

include_once 'BaseDAO.php';
//include_once '../util/plog/classes/plog.php';

class ProdTypeDAO extends BaseDAO{
	
	public function __construct () {
		parent::__construct();
//		$this->log = Plog::factory(__FILE__);			
	}
	
	public function queryAllWithSubType() {
		
		$sql = "select pt_id,m.type,pst_id,sub_type from prod_type m right join prod_sub_type s on m.pt_id=s.type order by pt_Id";
		$result = @mysql_query($sql);
		return $this->toArray($result);
	}
	


}
?>